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)