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) — 강퇴당했는지, 자진강퇴했는지