dev-meeting

Tables (9)

Member (유저)

  • member_id — Long — Primary key — NOT NULL
  • address_id (Key) — Long — Foreign key → address.address_id — NOT NULL
  • email (유니크값) — VARCHAR(100) — 이메일
  • password (Field7)
  • name (이름) — VARCHAR(30) — 이름
  • authority (Field3) — VARCHAR(10) — 권한
  • grade (Field4) — 평점
  • status (Field5) — active = 활동회원 out == 탈퇴회원
  • created_date (Field2) — date
  • last_update_date (Field6)

Study (Untitled2)

  • study_id (Key) — Long — Primary key — NOT NULL
  • subject_id (Key3) — Foreign key → Subject.subject_id — NOT NULL
  • title (Field) — 제목
  • create_date (Field2) — date
  • update_date (Field3) — date
  • max_member (Field4) — int
  • start_date (Field5) — date
  • end_date (Field6) — date
  • type (Field7) — int 1

Study_file (Untitled3)

  • Key — Primary key — NOT NULL
  • study_id (Key2) — Long — Foreign key → Study.study_id — NOT NULL
  • path (Field2) — varchar(100)
  • insert_date (Field3) — date
  • update_date (Field) — date
  • name (Field4)

Subject (주제)

  • subject_id (Key) — Primary key — NOT NULL
  • subject_name (Field) — VARCHAR(30)

address (Untitled4)

  • address_id (Key) — Long — Primary key — NOT NULL
  • address_1 (Field)
  • address_2 (Field2)
  • Field3

message (Untitled)

  • message_id (Key) — Long — Primary key — NOT NULL
  • member_id (2) — Long — Foreign key → Member.member_id — NOT NULL
  • content (Field2) — content
  • time (Field3) — date
  • status (Field4) — int 1
  • sender_name (Field) — Long
  • sender_name_id (Field5) — Long

online (Untitled7)

  • online_id (Key) — Long — Primary key — NOT NULL
  • study_id (Key2) — Long — Foreign key → Study.study_id — NOT NULL
  • online_type (Field)
  • link (Field2) — VARCHAR(150)

region (Untitled6)

  • region_Id (Key) — Long — Primary key — NOT NULL
  • address_id (Key2) — Long — Foreign key → address.address_id — NOT NULL
  • study_id (Key3) — Long — Foreign key → Study.study_id — NOT NULL

study_member (Untitled5)

  • study_member_id (Key) — Long — Primary key — NOT NULL
  • member_id (2) — Long — Foreign key → Member.member_id — NOT NULL
  • study_id (Key2) — Long — Foreign key → Study.study_id — NOT NULL
  • auth (Field)
  • status (Field2) — 강퇴당했는지, 자진강퇴했는지