ERDshfajr
Tables (10)
final (member_tbl)
- Num (num) — INT(11) — Primary key — NOT NULL
- Email (email) — VARCHAR(50)
- Is_enabled (is_enabled) — BIT(1)
- Name (name) — VARCHAR(50)
- Oauth (oauth) — VARCHAR(255)
- Password (password) — VARCHAR(100)
- Provider (provider) — VARCHAR(255)
- Provider_id (provider_id) — VARCHAR(255)
- Role (role) — VARCHATR(255)
- Username (username) — VARCHAR(100) — d
final (like_tbl)
- No (no) — INT(11) — Primary key — NOT NULL
- Content_id (content_id) — VARCHAR(80)
- Username (username) — VARCHAR(90)
final (notice_tbl)
- No (no) — INT(11) — Primary key — NOT NULL
- Moddate (moddate) — DATETIME(6)
- Regdate (regdate) — DATETIME(6)
- N_content (n_content) — VARCHAR(4000)
- N_title (n_title) — VARCHAR(500)
- N_writer (n_writer) — VARCHAR(100)
final (review_tbl)
- R_num (r_num) — INT(11) — Primary key — NOT NULL
- Content_id (content_id) — VARCHAR(500)
- Image (image) — VARCHAR(500)
- R_content (r_content) — VARCHAR(500)
- R_rating (r_rating) — INT(11)
final (diary_tbl)
- No (no) — INT(11) — Primary key — NOT NULL
- D_content (d_content) — VARCHAR(4000)
- D_title (d_title) — VARCHAR(500)
- D_username (d_username) — VARCHAR(100)
final (plan_tbl)
- No (no) — INT(11) — Primary key — NOT NULL
- Content_id (content_id) — VARCHAR(10)
- P_cday (p_cday) — VARCHAR(10)
- P_eday (p_eday) — VARCHAR(10)
- P_sday (p_sday) — VARCHAR(10)
- Username (username) — VARCHAR(20)
final (festa_tbl)
- F_no (f_no) — INT(11) — Primary key — NOT NULL
- F_lat (f_lat) — DOUBLE
- F_long (f_long) — DOUBLE
- F_review (f_review) — VARCHAR(1000)
final (confirmation_token)
- Token_id (token_id) — BIGINT(20) — Primary key — NOT NULL
- Confirmation_token (confirmation_token) — VARCHAR(255)
- Created_date (created_date) — DATETIME(6)
- Num (num) — INT(11)
final (trable_tbl)
- T_no (t_no) — INT(11) — Primary key — NOT NULL
- T_lat (t_lat) — DOUBLE
- T_long (t_long) — DOUBLE
- T_review (t_review) — VARCHAR(1000)
final (shop_tbl)
- S_no (s_no) — INT(11) — Primary key — NOT NULL
- S_lat (s_lat) — DOUBLE
- S_long (s_long) — DOUBLE
- S_review (s_review) — VARCHAR(1000)