OurFoodList/db_info.txt at master · DevelopDestroyer/OurFoodList · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
///////////////////////////////////


// 유저 정보
CREATE Table USER_MST(
    user_id     varchar(250),
    user_pw    varchar(400),
    user_email    varchar(250),
    level int, --기본회원, 유료회원, 관리자
    introduce   varchar(1000),
    avatar       varchar(128),
    create_date varchar(32),
    update_date varchar(32),
    status_cd    varchar(5),  --유저의 활성화 상태(회원상태, 탈퇴상태, 정지상태 등)
    primary key(user_id)
)


//매장 정보
CREATE Table STORE_MST
(
    store_id varchar(128) NOT NULL,
    store_name  varchar(128) NOT NULL,
    category   varchar(128),
    description   varchar(1000),
    telephone   varchar(32),
    address   varchar(500),
    roadaddress   varchar(128),
    lon   varchar(30),
    lat    varchar(30),
    create_date   varchar(30),
    primary key(store_id)
)


CREATE Table REVIEW_MST
(
  review_seq int NOT NULL AUTO_INCREMENT,
  user_id varchar(500),
  store_id varchar(128),
  visit_yn varchar(3),
  del_yn  varchar(3),
  rating varchar(5),
  review varchar(500),
  created varchar(30),
  updated varchar(30),
  primary key(review_seq)
)

CREATE Table REVIEW_TAG
(
  review_seq int,
  tag_code int
)

CREATE Table FRIENDS
(
  user_id  varchar(500),
  friend_id varchar(500)
)


CREATE Table GUESTBOOK
(
  guestbook_seq int NOT NULL AUTO_INCREMENT,
  ref_guestbook_seq int,
  to_user_id varchar(500),
  from_user_id varchar(500),
  del_yn  varchar(3),
  contents varchar(500),
  secret_yn varchar(3),
  created varchar(30),
  updated varchar(30),
  primary key(guestbook_seq)
)

CREATE Table COUPON_MST
(
  coupon_seq int NOT NULL AUTO_INCREMENT,
  coupon_key varchar(256),
  product_id int,
  total_amount int,
  remaining_amount int,
  created varchar(30),
  primary key(coupon_seq)
)

CREATE Table PREMIUM_HISTORY
(
  history_seq int NOT NULL AUTO_INCREMENT,
  user_id varchar(250),
  memo varchar(1000),
  created varchar(30),
  primary key(history_seq)
)


/////////////////////////////////////////////////////////////


Table STORE_REVIEW_ATTACH as review_attach{
  attach_idx String //auto increased
  review_idx String [ref: > review.review_idx]
  attach_url String
  created String
  updated String
}


// 유저의 팔로잉 정보
Table USER_FOLLOWING_RELATION as relation{
  relation_idx int //auto increased
	user_id String [ref: > users.user_id]
	follow_user_idx String
	status String //지켜보는 상태, 지켜보지 않는 상태
	created String
	updated String
}

* 로컬스토리지 정보
                      localStorage.setItem('gmatAutoLoginMode', 'on');
                      localStorage.setItem('gmatUserId', vm.inputID);
                      localStorage.setItem('gmatUserPw', );
                      localStorage.setItem('gmatTmpUserId', null);


if($_SESSION['userId'] != null)
"INSERT INTO GUESTBOOK (ref_guestbook_seq, to_user_id, from_user_id, del_yn, contents, secret_yn, created, updated)
VALUES (null, '".$toUserId."', '".$fromUserId."', '".$delYn."', '".$contents."', '".$secretYn."', '".date("Y-m-d H:i:s")."', '".date("Y-m-d H:i:s")."');";

if($_SESSION['userId'] == $fromId)
"UPDATE GUESTBOOK SET del_yn='".$delYn."', contents='".$contents."', secret_yn='".$secretYn."', updated='".$updated."' WHERE guestbook_seq = '".$guestbookSeq."';";