doldolseo

Tables (10)

crew_board_comment_tbl

  • CREW_POST_NO — NUMBER — Foreign key → crew_board_tbl.CREW_POST_NO — NOT NULL — UNIQUE
  • COMMENT — 'UNIQUE' — UNIQUE
  • _NO — NUMBER — NOT NULL — ID` VARCHAR2 NOT NULL COMMENT 'UNIQUE
  • CONTENT — VARCHAR2 — NOT NULL
  • W_DATE — DATE — NOT NULL

crew_board_tbl

  • CREW_POST_NO — NUMBER — Primary key — NOT NULL — UNIQUE
  • CREW_NO — NUMBER — Foreign key → crew_tbl.CREW_NO — NOT NULL — UNIQUE
  • ID — VARCHAR2 — Foreign key → member_tbl.ID — NOT NULL — UNIQUE
  • CATEGORY — VARCHAR2 — NOT NULL
  • TITLE — VARCHAR2 — NOT NULL
  • CONTENT — VARCHAR2 — NOT NULL
  • MEMBERLIST — VARCHAR2 — 멤버목록 삽입(id1/id2/...)
  • UPLOAD_IMAGE — VARCHAR2
  • W_DATE — DATE — NOT NULL
  • COUNT — NUMBER — NOT NULL

crew_member_tbl

  • CREW_REG_NO — NUMBER — Primary key — NOT NULL — UNIQUE
  • CREW_NO — NUMBER — Foreign key → crew_tbl.CREW_NO — NOT NULL — UNIQUE
  • MEBER_ID — VARCHAR2 — Foreign key → member_tbl.ID — NOT NULL — UNIQUE
  • STATE — BOOLEAN — NOT NULL — FALSE : 가입대기, TRUE : 가입승인

crew_tbl

  • CREW_NO — NUMBER — Primary key — NOT NULL — UNIQUE
  • ID — VARCHAR2 — Foreign key → member_tbl.ID — NOT NULL — UNIQUE
  • CREW_NAME — VARCHAR2 — NOT NULL — UNIQUE
  • AREALIST — VARCHAR2
  • INTRO — VARCHAR2 — NOT NULL
  • INTRO_DETAIL — VARCHAR2 — NOT NULL
  • RECRUIT — VARCHAR2 — NOT NULL
  • QUESTION1 — VARCHAR2 — NOT NULL
  • QUESTION2 — VARCHAR2
  • QUESTION3 — VARCHAR2 — 가입질문은 최대 3개 까지 생성 가능하게 코딩
  • MAIN_IMAGE — VARCHAR2
  • C_DATE — DATE — NOT NULL
  • GRADE — VARCHAR2 — NOT NULL
  • CREW_POINT — NUMBER — NOT NULL

member_tbl

  • ID — VARCHAR2 — Primary key — NOT NULL — UNIQUE
  • PASSWORD — VARCHAR2 — NOT NULL
  • NAME — VARCHAR2 — NOT NULL
  • NICKNAME — VARCHAR2 — NOT NULL — UNIQUE
  • MEMBER_IMG — VARCHAR2
  • BIRTH — DATE — NOT NULL
  • GENDER — VARCHAR2 — NOT NULL
  • EMAIL — VARCHAR2 — NOT NULL
  • PHONE — VARCHAR2
  • CRLEADER — CAHR

plan_tbl

  • PLAN_NO — NUMBER — Primary key — NOT NULL — UNIQUE
  • PLANNER_NO — NUMBER — Foreign key → planner_tbl.PLANNER_NO — NOT NULL
  • DATE — DATE — NOT NULL — 날짜-시-분
  • NAME — VARCHAR2 — NOT NULL
  • INTRO — VARCHAR2
  • X — NUMBER — NOT NULL
  • Y — NUMBER — NOT NULL

planner_tbl

  • PLANNER_NO — NUMBER — Primary key — NOT NULL — UNIQUE
  • ID — VARCHAR2 — Foreign key → member_tbl.ID — NOT NULL — UNIQUE
  • TITLE — VARCHAR2 — NOT NULL
  • F_DATE — DATE — NOT NULL
  • L_DATE — DATE — NOT NULL
  • INTRO — VARCHAR2
  • W_DATE — DATE — NOT NULL

review_board_comment_tbl

  • ID — VARCHAR2 — Foreign key → member_tbl.ID — NOT NULL — UNIQUE
  • COMMENT — 'UNIQUE' — UNIQUE
  • _NO — NUMBER — NOT NULL — REVIEW_NO` NUMBER NOT NULL DEFAULT 1 COMMENT 'UNIQUE
  • content — VARCHAR2 — NOT NULL
  • W_DATE — DATE — NOT NULL

review_board_tbl

  • REVIEW_NO — NUMBER — Primary key — NOT NULL — UNIQUE
  • ID — VARCHAR2 — Foreign key → member_tbl.ID — NOT NULL — UNIQUE
  • AREA_NO — NUMBER — NOT NULL
  • TITLE — VARCHAR2 — NOT NULL
  • CONTENT — VARCHAR2 — NOT NULL
  • COUSE_IMG — VARCHAR2
  • UPLOAD_IMG — VARCHAR2
  • W_DATE — DATE — NOT NULL
  • HIT — NUMBER — NOT NULL

seoul_area_tbl

  • NAME — VARCHAR2 — Primary key — NOT NULL — title
  • ADDRESS — VARCHAR2 — addr1
  • SIGUNGU — NUMBER — NOT NULL — sigungucode
  • ZIPCODE — NUMBER — zipcode
  • TEL — VARCHAR2 — tel
  • X — NUMBER — mapx
  • Y — NUMBER — mapy
  • IMAGE1 — VARCHAR2 — firstimage
  • IMAGE2 — VARCHAR2 — firstimage2
  • CONTENTID — NUMBER — NOT NULL — contentid
  • CONTENTTYPE — number — NOT NULL — contenttypeid